﻿CREATE PROCEDURE dbo.procPrintError
AS

/*******************************************************************************
 **        Name: procPrintError
 ** Description: Prints error information about the error that caused execution
 **              jump to the CATCH block of a TRY...CATCH construct.  Should be
 **              executed from within the scope of a CATCH block otherwise it
 **              will return without printing any error information.
 *******************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  02/21/2009  Chad Green             11774    Initial Development
 ****************************************************************************************************/

BEGIN
  SET NOCOUNT ON;
  PRINT 'Error ' + CONVERT(varchar(50), ERROR_NUMBER()) +
        ', Severity ' + CONVERT(varchar(5), ERROR_SEVERITY()) +
        ', State ' + CONVERT(varchar(5), ERROR_STATE()) + 
        ', Procedure ' + ISNULL(ERROR_PROCEDURE(), '-') + 
        ', Line ' + CONVERT(varchar(5), ERROR_LINE());
  PRINT ERROR_MESSAGE();
END;
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'procPrintError'
GO